public DataSet getds(string M_str_sqlstr, string M_str_table)  //查询
         /// <summary>
        /// <summary>
        #endregion
            return sqlread;
        /// <param>SQL语句</param>
            sqlcon.Open();
        public void getcom(string M_str_sqlstr)
            DataSet myds = new DataSet();
            try
        /// </summary>
                sqlcon.Dispose();
{
            SqlDataReader sqlread = sqlcom.ExecuteReader(CommandBehavior.CloseConnection);
            SqlConnection sqlcon = this.getcon();
        /// <returns>返回DataSet对象</returns>
    /// </summary>
        #region  执行SqlCommand命令

using System;
        #region  创建DataSet对象
        {
            {
        /// 建立数据库连接.
            SqlConnection sqlcon = this.getcon();   //获取连接字符串
        }
namespace yjgl
        /// 执行SqlCommand
            {
         /// 创建一个SqlDataReader对象
            finally
            SqlCommand sqlcom = new SqlCommand(M_str_sqlstr, sqlcon);
using System.Data.SqlClient;
        /// <summary>
        /// 创建一个DataSet对象
        {
                sqlcon.Close();

复制代码 代码如下:

        /// <summary>
                sqlcom.Dispose();           //释放sqlcom'
        }
    class BaseOperate
        #endregion
                sqlcom.ExecuteNonQuery();     //对sqlcon执行SQL语句并返回受影响的行数
            sqlda.Fill(myds, M_str_table);
            SqlDataAdapter sqlda = new SqlDataAdapter(M_str_sqlstr, sqlcon);
            sqlcon.Open();       //打开连接
        /// </summary>
        /// <returns>返回SqlConnection对象</returns>
            return mycon;
         }
         #region  创建SqlDataReader对象
            string M_str_sqlcon = "Data Source=PC-200201010009 ;Database=db_yjzl;User ID=sa;PWD=123";//连接字符串
         /// </summary>
        {
    }
            }
            catch (SqlException e)
            }
         /// <param>SQL语句</param>
        #endregion
}

         /// <returns>返回SqlDataReader对象</returns>
using System.Data;
        /// <param>表名</param>
using System.Text;
            SqlConnection sqlcon = this.getcon();
            return myds;
        public SqlDataReader getread(string M_str_sqlstr)
        /// </summary>
         }
        #endregion
        #region  建立数据库连接
        {
    /// 数据访问基础类(SQL)   
                SqlCommand sqlcom = new SqlCommand(M_str_sqlstr, sqlcon);  //通过SQL语句和连接对象创建命令对象
    /// <summary>   
        public SqlConnection getcon()
                MessageBox.Show(e.ToString(), "信息提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
            {
using System.Windows.Forms;
using System.Collections.Generic;
            }
    {
            SqlConnection mycon = new SqlConnection(M_str_sqlcon);      //创建连接对象
        /// <param>SQL语句</param>